Physical Inventory Report

The Physical Inventory Report is used to produce a count sheet that can be used to record the physical inventory count. The report can be run by department or location as a regular count sheet, which includes all the items for the department(s). It can also be run using the cycle count, which uses a predetermined selection of items to count based on the department and item cycle count classification features for unlotted items. The report can be used along with the Inventory Reconciliation to quickly reconcile the physical count to the on-hand balance for unlotted items. When printed, the floor copy of the report contains blank lines on which the physical count can be written and returned to management for reconciliation.

Use the Physical Slot Inventory Report for a report by slot if the location is slotted.

Physical Inventory Report Fields

Location/Department   Enter one, several, or all locations/departments (depending on whether you are running the report by location(s) or department(s)) to generate the report for. If the report is being generated for a department, select whether to generate a regular report or cycle count. Item Enter the item maskA mask is used to conduct a wild card search. Visually a mask is represented by a series of forward slash marks (///), sometimes with a letter, letters, or number(s) preceding it (1/// or AB///). For example, if you enter ////////, this indicates that you want to list all items defined in the system. If you enter in 1//1//1/, this indicates that you want the system to list items that have the digit "1" in those locations. to generate the report for. Print Slot (Y/N) Enter Y (Y=yes) to include slot detail on the report, enter N (N=no) to include just the lot total. Print Zero (Y/N) Enter Y (Y=yes) to include all items with a current on-hand balance or zero. Enter N (N=no) to include items with a non-zero on-hand balance.   (F)loor/(M)gmt Select M (M=management) to include the on-hand quantity of the item on the report; select F (F=floor) and the on-hand quantity will not appear on the report.

Security Required : Inventory - Inventory Reports